CREATE TABLE [dbo].[FS_GSO_Trades]
(
[GroupType] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IntraFundTrade] [float] NULL,
[BlotterID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BlotterTradeID] [float] NULL,
[BlotterDate] [date] NULL,
[TradeDate] [date] NULL,
[SettleDate] [date] NULL,
[DirectionID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TotalTradeQty] [float] NULL,
[CostPrice] [float] NULL,
[CurrencyID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BlotterTradeStatusID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContrapartyName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IssuerID] [float] NULL,
[IssuerName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IssuerXSrc] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssetType] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssetID] [float] NULL,
[AssetName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssetXSrc] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CommissionTypeCode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Commission] [float] NULL,
[AnalystName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TraderName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DefaultAllocationName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TradeTypeName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderExecutionTypeName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AllocationReason] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CountryID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdateDateTime] [date] NULL,
[UpdateUserID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FundID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AllocatedQuantity] [float] NULL,
[MaturityDate] [date] NULL,
[CUSIP] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISIN] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LoanX] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ticker] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IssueRatingMoodys] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IssueRatingSP] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InterestAccrualType] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InterestFrequency] [float] NULL,
[InterestSpreadRate] [float] NULL,
[InterestRate] [float] NULL,
[IssueAmount] [float] NULL,
[IndustryNameMoodys] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IndustryNameSP] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
